Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CalendarID (PK) | A unique system assigned identifier for the Calendar. | ID_CLD | Identity | int | |
BusinessDayDate (PK) | The calendar date of the BusinessDay. | DC_DY_BSN | DateCalendar | date | |
CalendarName | The name of the Calendar | NM_CLD | Name | varchar(40) | |
ParentLevelID | A unique system assigned identifier for the CalendarLevel. | ID_CLD_LV_PRNT | Identity | int | |
ChildPeriodID | A unique system assigned identifier for this CalendarPeriod | ID_CLD_PRD_CHLD | Identity | int | |
CalendarPeriodHierarchyIDTreePath | A pipe delimited, bottom up (left to right) list of calendar period ID's for a calendar period hierarchy. | CLD_PRD_ID_TREE_PTH | String | varchar(4000) | |
CalendarPeriodHierarchyLevelPath | A pipe delimited, bottom up (left to right) list of calendar period hierarchy level numbers for a calendar period hierarchy. | CLD_PRD_LVL_PTH | String | varchar(4000) | |
CalendarPeriodHierarchyLevelNamePath | A pipe delimited, bottom up (left to right) list of calendar period hierarchy level names for a calendar period hierarchy | CLD_PRD_LVL_NM_PTH | String | varchar(4000) | |